﻿CREATE TABLE [dbo].[Grupp] (
    [Id]        UNIQUEIDENTIFIER NOT NULL,
    [ValId]     UNIQUEIDENTIFIER NOT NULL,
    [Skapad]    DATETIME         NOT NULL,
    [SkapadAv]  NVARCHAR (50)    NOT NULL,
    [Andrad]    DATETIME         NULL,
    [AndradAv]  NVARCHAR (50)    NULL,
    [Benamning] NVARCHAR (50)    NOT NULL,
    [Fritext]   TEXT             NULL,
    CONSTRAINT [PK_Grupp] PRIMARY KEY CLUSTERED ([Id] ASC, [ValId] ASC), 
    CONSTRAINT [FK_Grupp_Val] FOREIGN KEY ([ValId]) REFERENCES [Val]([Id])
);



